Manage fields in the XML database

Before you can manage fields in the XML database, you must get access to editing CFG files.

Create a new field in the XML database

1. In the InfoScan Setup window, click in the toolbar to open the In the Database Setup window.
2. Click the browse button (…) next to the Database Connection field. The The Set XML Fields window opens.
   
3. In the Fields list, enter the name of the new field in an empty field.

• You can use any names for the fields except for the name iskonsep, which is reserved. The content of the iskonsep field defines whether a cover page is an envelope cover page or a document cover page. See Types of cover pages.
• Single-value fields must be placed before multi-value fields in the Fields list. If you need to change the order of fields, see Move a field in the XML database.

3. In the Field Type group box, select one of the options below:

• InfoScan Field - The field is placed in the <dkfm:metadata> part of the finished XML files.
• SJ Field or SJ Group - The field is placed in the <sj:metadata> part of the finished XML files.

For single-value fields, select SJ Field in the Field Type group box.

The content of the window changes according to the selected option.

4. In the fields below the Field Type Attributes and the Additional Attributes, enter the field attributes. See the description of the attributes in The Set XML Fields window.

• For single-value fields, both the group name and the field name must be entered in the sjfieldname field. The group name and the field name must be separated by a colon. For example, ekstra:loa_pst, where ekstra is the group name and loa_pst is the field name.
• For fields used for a date, you must enter the text ISO8601 in the sjscheme field. Use only the format YYYY-MM-DD for a date.

5. In the Use XSLT file to transform output field, enter the name of the XSLT file to be used for transformation of the XML file, which is generated by the InfoScan programs.

The full path to the file must be specified.

6. Click OK to close the Set XML Fields window. The new field is defined.

Edit a field in the XML database

1. In the InfoScan Setup window, click in the toolbar to open the Database Setup window.
2. Click the browse button (…) next to the Database Connection field. The Set XML Fields window opens.
3. In the Fields list, select the field that you want to edit. The attributes of the selected field are displayed to the right.
4. Edit the attributes as required (see a description of the attributes in The Set XML Fields window) and then click OK. The Set XML Fields window closes, and the attribute values have been changed.

Move a field in the XML database

1. In the InfoScan Setup window, click in the toolbar to open the Database Setup window.
2. Click the browse button (…) next to the Database Connection field. The Set XML Fields window opens.
3. Click the Reorder Fields button.
   A del button next to each field in the Fields list is activated, and the text on the Reorder Fields button is changed to Edit/Add Fields.
4. Use “drag-and-drop” to move the fields.

Single-value fields must be placed before multi-value fields in the Fields list.

5. Click OK to close the Set XML Fields window when you have finished moving the fields.

Delete a field in the XML database

1. In the InfoScan Setup window, click in the toolbar to open the Database Setup window.
2. Click the browse button (…) next to the Database Connection field. The Set XML Fields window appears.
3. Click the Reorder Fields button.
   The del button next to each field in the Fields list is activated, and the text on the Reorder Fields is changed to Edit/Add Fields.
4. Click del next to the field that you want to delete. The selected field is deleted.
5. Click OK to close the Set XML Fields window.

Configure a default value for a field

1. In the InfoScan Setup window, click in the toolbar to open the Database Setup window.
2. In the Selected Fields list, double-click the field for which you want to define a default value. The Edit Field - <field name> window opens.
3. In the Default Value group box, select a radio button.
   • None - No default value will be assigned to the field. Go to step 5.
   • User Defined or System Defined - You can assign a default value to the field as described in step 4.

   By default the following user defined values are used:

   • Forfatter [Author]: #TOM#
   • Afsendt fra [sent from]: #TOM#
   • Afsendt af [sent by]: #TOM#
4. Enter a value in the field next to User Defined or select a value from the list next to System Defined.

If you enter a value in the field next to User Defined , you must make sure that the value complies with the OIO standard.

5. Click OK. The Edit Field - <field name> window closes, and the default value for the field is defined.

Configure an additional property for a field

To configure additional properties for a field in the XML database, you can specify characters to be added as prefix or postfix (suffix) to the value of a field, or you can copy the value of a field to another field.

1. In the InfoScan Setup window, click in the toolbar to open the Database Setup window.
2. In the Selected Fields list, double-click the field for which you want to define a default value. The Edit Field - <field name> window appears.
3. In the Extended Field Properties group box, do one or more of the following:
   • In the Fixed Prefix field, enter the characters that you want to be a prefix to the value of the field that you selected in step 2.
   • In the Fixed Postfix field, enter the characters that you want to be a postfix to the value of the field that you selected in step 2.
   • In the Copy Regvalue to Field field, enter the name of the field to which you want to copy the value of the field that you selected in the step 2.
   • In the Copy Finalvalue to Field field, enter the name of the field to which you want to copy the value of the field that you selected in step 2, including prefix/postfix.

4. Click OK. The Edit Field - <field name> window closes and the additional properties for the field are defined.